package com.wn.purchaeReturn.entity;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.List;

public class PurPurchasebilldetailExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    private Integer limit;

    private Long offset;

    public PurPurchasebilldetailExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void setLimit(Integer limit) {
        this.limit = limit;
    }

    public Integer getLimit() {
        return limit;
    }

    public void setOffset(Long offset) {
        this.offset = offset;
    }

    public Long getOffset() {
        return offset;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andPurchasenoIsNull() {
            addCriterion("PURCHASENO is null");
            return (Criteria) this;
        }

        public Criteria andPurchasenoIsNotNull() {
            addCriterion("PURCHASENO is not null");
            return (Criteria) this;
        }

        public Criteria andPurchasenoEqualTo(String value) {
            addCriterion("PURCHASENO =", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoNotEqualTo(String value) {
            addCriterion("PURCHASENO <>", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoGreaterThan(String value) {
            addCriterion("PURCHASENO >", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoGreaterThanOrEqualTo(String value) {
            addCriterion("PURCHASENO >=", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoLessThan(String value) {
            addCriterion("PURCHASENO <", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoLessThanOrEqualTo(String value) {
            addCriterion("PURCHASENO <=", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoLike(String value) {
            addCriterion("PURCHASENO like", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoNotLike(String value) {
            addCriterion("PURCHASENO not like", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoIn(List<String> values) {
            addCriterion("PURCHASENO in", values, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoNotIn(List<String> values) {
            addCriterion("PURCHASENO not in", values, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoBetween(String value1, String value2) {
            addCriterion("PURCHASENO between", value1, value2, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoNotBetween(String value1, String value2) {
            addCriterion("PURCHASENO not between", value1, value2, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchaselnoIsNull() {
            addCriterion("PURCHASELNO is null");
            return (Criteria) this;
        }

        public Criteria andPurchaselnoIsNotNull() {
            addCriterion("PURCHASELNO is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaselnoEqualTo(Integer value) {
            addCriterion("PURCHASELNO =", value, "purchaselno");
            return (Criteria) this;
        }

        public Criteria andPurchaselnoNotEqualTo(Integer value) {
            addCriterion("PURCHASELNO <>", value, "purchaselno");
            return (Criteria) this;
        }

        public Criteria andPurchaselnoGreaterThan(Integer value) {
            addCriterion("PURCHASELNO >", value, "purchaselno");
            return (Criteria) this;
        }

        public Criteria andPurchaselnoGreaterThanOrEqualTo(Integer value) {
            addCriterion("PURCHASELNO >=", value, "purchaselno");
            return (Criteria) this;
        }

        public Criteria andPurchaselnoLessThan(Integer value) {
            addCriterion("PURCHASELNO <", value, "purchaselno");
            return (Criteria) this;
        }

        public Criteria andPurchaselnoLessThanOrEqualTo(Integer value) {
            addCriterion("PURCHASELNO <=", value, "purchaselno");
            return (Criteria) this;
        }

        public Criteria andPurchaselnoIn(List<Integer> values) {
            addCriterion("PURCHASELNO in", values, "purchaselno");
            return (Criteria) this;
        }

        public Criteria andPurchaselnoNotIn(List<Integer> values) {
            addCriterion("PURCHASELNO not in", values, "purchaselno");
            return (Criteria) this;
        }

        public Criteria andPurchaselnoBetween(Integer value1, Integer value2) {
            addCriterion("PURCHASELNO between", value1, value2, "purchaselno");
            return (Criteria) this;
        }

        public Criteria andPurchaselnoNotBetween(Integer value1, Integer value2) {
            addCriterion("PURCHASELNO not between", value1, value2, "purchaselno");
            return (Criteria) this;
        }

        public Criteria andProdcdIsNull() {
            addCriterion("PRODCD is null");
            return (Criteria) this;
        }

        public Criteria andProdcdIsNotNull() {
            addCriterion("PRODCD is not null");
            return (Criteria) this;
        }

        public Criteria andProdcdEqualTo(String value) {
            addCriterion("PRODCD =", value, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdNotEqualTo(String value) {
            addCriterion("PRODCD <>", value, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdGreaterThan(String value) {
            addCriterion("PRODCD >", value, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdGreaterThanOrEqualTo(String value) {
            addCriterion("PRODCD >=", value, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdLessThan(String value) {
            addCriterion("PRODCD <", value, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdLessThanOrEqualTo(String value) {
            addCriterion("PRODCD <=", value, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdLike(String value) {
            addCriterion("PRODCD like", value, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdNotLike(String value) {
            addCriterion("PRODCD not like", value, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdIn(List<String> values) {
            addCriterion("PRODCD in", values, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdNotIn(List<String> values) {
            addCriterion("PRODCD not in", values, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdBetween(String value1, String value2) {
            addCriterion("PRODCD between", value1, value2, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdNotBetween(String value1, String value2) {
            addCriterion("PRODCD not between", value1, value2, "prodcd");
            return (Criteria) this;
        }

        public Criteria andLotnoIsNull() {
            addCriterion("LOTNO is null");
            return (Criteria) this;
        }

        public Criteria andLotnoIsNotNull() {
            addCriterion("LOTNO is not null");
            return (Criteria) this;
        }

        public Criteria andLotnoEqualTo(String value) {
            addCriterion("LOTNO =", value, "lotno");
            return (Criteria) this;
        }

        public Criteria andLotnoNotEqualTo(String value) {
            addCriterion("LOTNO <>", value, "lotno");
            return (Criteria) this;
        }

        public Criteria andLotnoGreaterThan(String value) {
            addCriterion("LOTNO >", value, "lotno");
            return (Criteria) this;
        }

        public Criteria andLotnoGreaterThanOrEqualTo(String value) {
            addCriterion("LOTNO >=", value, "lotno");
            return (Criteria) this;
        }

        public Criteria andLotnoLessThan(String value) {
            addCriterion("LOTNO <", value, "lotno");
            return (Criteria) this;
        }

        public Criteria andLotnoLessThanOrEqualTo(String value) {
            addCriterion("LOTNO <=", value, "lotno");
            return (Criteria) this;
        }

        public Criteria andLotnoLike(String value) {
            addCriterion("LOTNO like", value, "lotno");
            return (Criteria) this;
        }

        public Criteria andLotnoNotLike(String value) {
            addCriterion("LOTNO not like", value, "lotno");
            return (Criteria) this;
        }

        public Criteria andLotnoIn(List<String> values) {
            addCriterion("LOTNO in", values, "lotno");
            return (Criteria) this;
        }

        public Criteria andLotnoNotIn(List<String> values) {
            addCriterion("LOTNO not in", values, "lotno");
            return (Criteria) this;
        }

        public Criteria andLotnoBetween(String value1, String value2) {
            addCriterion("LOTNO between", value1, value2, "lotno");
            return (Criteria) this;
        }

        public Criteria andLotnoNotBetween(String value1, String value2) {
            addCriterion("LOTNO not between", value1, value2, "lotno");
            return (Criteria) this;
        }

        public Criteria andPurchaseqntyIsNull() {
            addCriterion("PURCHASEQNTY is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseqntyIsNotNull() {
            addCriterion("PURCHASEQNTY is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseqntyEqualTo(Integer value) {
            addCriterion("PURCHASEQNTY =", value, "purchaseqnty");
            return (Criteria) this;
        }

        public Criteria andPurchaseqntyNotEqualTo(Integer value) {
            addCriterion("PURCHASEQNTY <>", value, "purchaseqnty");
            return (Criteria) this;
        }

        public Criteria andPurchaseqntyGreaterThan(Integer value) {
            addCriterion("PURCHASEQNTY >", value, "purchaseqnty");
            return (Criteria) this;
        }

        public Criteria andPurchaseqntyGreaterThanOrEqualTo(Integer value) {
            addCriterion("PURCHASEQNTY >=", value, "purchaseqnty");
            return (Criteria) this;
        }

        public Criteria andPurchaseqntyLessThan(Integer value) {
            addCriterion("PURCHASEQNTY <", value, "purchaseqnty");
            return (Criteria) this;
        }

        public Criteria andPurchaseqntyLessThanOrEqualTo(Integer value) {
            addCriterion("PURCHASEQNTY <=", value, "purchaseqnty");
            return (Criteria) this;
        }

        public Criteria andPurchaseqntyIn(List<Integer> values) {
            addCriterion("PURCHASEQNTY in", values, "purchaseqnty");
            return (Criteria) this;
        }

        public Criteria andPurchaseqntyNotIn(List<Integer> values) {
            addCriterion("PURCHASEQNTY not in", values, "purchaseqnty");
            return (Criteria) this;
        }

        public Criteria andPurchaseqntyBetween(Integer value1, Integer value2) {
            addCriterion("PURCHASEQNTY between", value1, value2, "purchaseqnty");
            return (Criteria) this;
        }

        public Criteria andPurchaseqntyNotBetween(Integer value1, Integer value2) {
            addCriterion("PURCHASEQNTY not between", value1, value2, "purchaseqnty");
            return (Criteria) this;
        }

        public Criteria andBasicpurchaseqntyIsNull() {
            addCriterion("BASICPURCHASEQNTY is null");
            return (Criteria) this;
        }

        public Criteria andBasicpurchaseqntyIsNotNull() {
            addCriterion("BASICPURCHASEQNTY is not null");
            return (Criteria) this;
        }

        public Criteria andBasicpurchaseqntyEqualTo(Integer value) {
            addCriterion("BASICPURCHASEQNTY =", value, "basicpurchaseqnty");
            return (Criteria) this;
        }

        public Criteria andBasicpurchaseqntyNotEqualTo(Integer value) {
            addCriterion("BASICPURCHASEQNTY <>", value, "basicpurchaseqnty");
            return (Criteria) this;
        }

        public Criteria andBasicpurchaseqntyGreaterThan(Integer value) {
            addCriterion("BASICPURCHASEQNTY >", value, "basicpurchaseqnty");
            return (Criteria) this;
        }

        public Criteria andBasicpurchaseqntyGreaterThanOrEqualTo(Integer value) {
            addCriterion("BASICPURCHASEQNTY >=", value, "basicpurchaseqnty");
            return (Criteria) this;
        }

        public Criteria andBasicpurchaseqntyLessThan(Integer value) {
            addCriterion("BASICPURCHASEQNTY <", value, "basicpurchaseqnty");
            return (Criteria) this;
        }

        public Criteria andBasicpurchaseqntyLessThanOrEqualTo(Integer value) {
            addCriterion("BASICPURCHASEQNTY <=", value, "basicpurchaseqnty");
            return (Criteria) this;
        }

        public Criteria andBasicpurchaseqntyIn(List<Integer> values) {
            addCriterion("BASICPURCHASEQNTY in", values, "basicpurchaseqnty");
            return (Criteria) this;
        }

        public Criteria andBasicpurchaseqntyNotIn(List<Integer> values) {
            addCriterion("BASICPURCHASEQNTY not in", values, "basicpurchaseqnty");
            return (Criteria) this;
        }

        public Criteria andBasicpurchaseqntyBetween(Integer value1, Integer value2) {
            addCriterion("BASICPURCHASEQNTY between", value1, value2, "basicpurchaseqnty");
            return (Criteria) this;
        }

        public Criteria andBasicpurchaseqntyNotBetween(Integer value1, Integer value2) {
            addCriterion("BASICPURCHASEQNTY not between", value1, value2, "basicpurchaseqnty");
            return (Criteria) this;
        }

        public Criteria andRealqntyIsNull() {
            addCriterion("REALQNTY is null");
            return (Criteria) this;
        }

        public Criteria andRealqntyIsNotNull() {
            addCriterion("REALQNTY is not null");
            return (Criteria) this;
        }

        public Criteria andRealqntyEqualTo(Integer value) {
            addCriterion("REALQNTY =", value, "realqnty");
            return (Criteria) this;
        }

        public Criteria andRealqntyNotEqualTo(Integer value) {
            addCriterion("REALQNTY <>", value, "realqnty");
            return (Criteria) this;
        }

        public Criteria andRealqntyGreaterThan(Integer value) {
            addCriterion("REALQNTY >", value, "realqnty");
            return (Criteria) this;
        }

        public Criteria andRealqntyGreaterThanOrEqualTo(Integer value) {
            addCriterion("REALQNTY >=", value, "realqnty");
            return (Criteria) this;
        }

        public Criteria andRealqntyLessThan(Integer value) {
            addCriterion("REALQNTY <", value, "realqnty");
            return (Criteria) this;
        }

        public Criteria andRealqntyLessThanOrEqualTo(Integer value) {
            addCriterion("REALQNTY <=", value, "realqnty");
            return (Criteria) this;
        }

        public Criteria andRealqntyIn(List<Integer> values) {
            addCriterion("REALQNTY in", values, "realqnty");
            return (Criteria) this;
        }

        public Criteria andRealqntyNotIn(List<Integer> values) {
            addCriterion("REALQNTY not in", values, "realqnty");
            return (Criteria) this;
        }

        public Criteria andRealqntyBetween(Integer value1, Integer value2) {
            addCriterion("REALQNTY between", value1, value2, "realqnty");
            return (Criteria) this;
        }

        public Criteria andRealqntyNotBetween(Integer value1, Integer value2) {
            addCriterion("REALQNTY not between", value1, value2, "realqnty");
            return (Criteria) this;
        }

        public Criteria andBasicrealqntyIsNull() {
            addCriterion("BASICREALQNTY is null");
            return (Criteria) this;
        }

        public Criteria andBasicrealqntyIsNotNull() {
            addCriterion("BASICREALQNTY is not null");
            return (Criteria) this;
        }

        public Criteria andBasicrealqntyEqualTo(Integer value) {
            addCriterion("BASICREALQNTY =", value, "basicrealqnty");
            return (Criteria) this;
        }

        public Criteria andBasicrealqntyNotEqualTo(Integer value) {
            addCriterion("BASICREALQNTY <>", value, "basicrealqnty");
            return (Criteria) this;
        }

        public Criteria andBasicrealqntyGreaterThan(Integer value) {
            addCriterion("BASICREALQNTY >", value, "basicrealqnty");
            return (Criteria) this;
        }

        public Criteria andBasicrealqntyGreaterThanOrEqualTo(Integer value) {
            addCriterion("BASICREALQNTY >=", value, "basicrealqnty");
            return (Criteria) this;
        }

        public Criteria andBasicrealqntyLessThan(Integer value) {
            addCriterion("BASICREALQNTY <", value, "basicrealqnty");
            return (Criteria) this;
        }

        public Criteria andBasicrealqntyLessThanOrEqualTo(Integer value) {
            addCriterion("BASICREALQNTY <=", value, "basicrealqnty");
            return (Criteria) this;
        }

        public Criteria andBasicrealqntyIn(List<Integer> values) {
            addCriterion("BASICREALQNTY in", values, "basicrealqnty");
            return (Criteria) this;
        }

        public Criteria andBasicrealqntyNotIn(List<Integer> values) {
            addCriterion("BASICREALQNTY not in", values, "basicrealqnty");
            return (Criteria) this;
        }

        public Criteria andBasicrealqntyBetween(Integer value1, Integer value2) {
            addCriterion("BASICREALQNTY between", value1, value2, "basicrealqnty");
            return (Criteria) this;
        }

        public Criteria andBasicrealqntyNotBetween(Integer value1, Integer value2) {
            addCriterion("BASICREALQNTY not between", value1, value2, "basicrealqnty");
            return (Criteria) this;
        }

        public Criteria andUnitcdIsNull() {
            addCriterion("UNITCD is null");
            return (Criteria) this;
        }

        public Criteria andUnitcdIsNotNull() {
            addCriterion("UNITCD is not null");
            return (Criteria) this;
        }

        public Criteria andUnitcdEqualTo(String value) {
            addCriterion("UNITCD =", value, "unitcd");
            return (Criteria) this;
        }

        public Criteria andUnitcdNotEqualTo(String value) {
            addCriterion("UNITCD <>", value, "unitcd");
            return (Criteria) this;
        }

        public Criteria andUnitcdGreaterThan(String value) {
            addCriterion("UNITCD >", value, "unitcd");
            return (Criteria) this;
        }

        public Criteria andUnitcdGreaterThanOrEqualTo(String value) {
            addCriterion("UNITCD >=", value, "unitcd");
            return (Criteria) this;
        }

        public Criteria andUnitcdLessThan(String value) {
            addCriterion("UNITCD <", value, "unitcd");
            return (Criteria) this;
        }

        public Criteria andUnitcdLessThanOrEqualTo(String value) {
            addCriterion("UNITCD <=", value, "unitcd");
            return (Criteria) this;
        }

        public Criteria andUnitcdLike(String value) {
            addCriterion("UNITCD like", value, "unitcd");
            return (Criteria) this;
        }

        public Criteria andUnitcdNotLike(String value) {
            addCriterion("UNITCD not like", value, "unitcd");
            return (Criteria) this;
        }

        public Criteria andUnitcdIn(List<String> values) {
            addCriterion("UNITCD in", values, "unitcd");
            return (Criteria) this;
        }

        public Criteria andUnitcdNotIn(List<String> values) {
            addCriterion("UNITCD not in", values, "unitcd");
            return (Criteria) this;
        }

        public Criteria andUnitcdBetween(String value1, String value2) {
            addCriterion("UNITCD between", value1, value2, "unitcd");
            return (Criteria) this;
        }

        public Criteria andUnitcdNotBetween(String value1, String value2) {
            addCriterion("UNITCD not between", value1, value2, "unitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdIsNull() {
            addCriterion("BASICUNITCD is null");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdIsNotNull() {
            addCriterion("BASICUNITCD is not null");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdEqualTo(String value) {
            addCriterion("BASICUNITCD =", value, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdNotEqualTo(String value) {
            addCriterion("BASICUNITCD <>", value, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdGreaterThan(String value) {
            addCriterion("BASICUNITCD >", value, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdGreaterThanOrEqualTo(String value) {
            addCriterion("BASICUNITCD >=", value, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdLessThan(String value) {
            addCriterion("BASICUNITCD <", value, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdLessThanOrEqualTo(String value) {
            addCriterion("BASICUNITCD <=", value, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdLike(String value) {
            addCriterion("BASICUNITCD like", value, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdNotLike(String value) {
            addCriterion("BASICUNITCD not like", value, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdIn(List<String> values) {
            addCriterion("BASICUNITCD in", values, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdNotIn(List<String> values) {
            addCriterion("BASICUNITCD not in", values, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdBetween(String value1, String value2) {
            addCriterion("BASICUNITCD between", value1, value2, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdNotBetween(String value1, String value2) {
            addCriterion("BASICUNITCD not between", value1, value2, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceIsNull() {
            addCriterion("PURCHASEPRICE is null");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceIsNotNull() {
            addCriterion("PURCHASEPRICE is not null");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceEqualTo(BigDecimal value) {
            addCriterion("PURCHASEPRICE =", value, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceNotEqualTo(BigDecimal value) {
            addCriterion("PURCHASEPRICE <>", value, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceGreaterThan(BigDecimal value) {
            addCriterion("PURCHASEPRICE >", value, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PURCHASEPRICE >=", value, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceLessThan(BigDecimal value) {
            addCriterion("PURCHASEPRICE <", value, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PURCHASEPRICE <=", value, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceIn(List<BigDecimal> values) {
            addCriterion("PURCHASEPRICE in", values, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceNotIn(List<BigDecimal> values) {
            addCriterion("PURCHASEPRICE not in", values, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PURCHASEPRICE between", value1, value2, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PURCHASEPRICE not between", value1, value2, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andTaxIsNull() {
            addCriterion("TAX is null");
            return (Criteria) this;
        }

        public Criteria andTaxIsNotNull() {
            addCriterion("TAX is not null");
            return (Criteria) this;
        }

        public Criteria andTaxEqualTo(BigDecimal value) {
            addCriterion("TAX =", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxNotEqualTo(BigDecimal value) {
            addCriterion("TAX <>", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxGreaterThan(BigDecimal value) {
            addCriterion("TAX >", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("TAX >=", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxLessThan(BigDecimal value) {
            addCriterion("TAX <", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxLessThanOrEqualTo(BigDecimal value) {
            addCriterion("TAX <=", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxIn(List<BigDecimal> values) {
            addCriterion("TAX in", values, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxNotIn(List<BigDecimal> values) {
            addCriterion("TAX not in", values, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TAX between", value1, value2, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TAX not between", value1, value2, "tax");
            return (Criteria) this;
        }

        public Criteria andTotalmnyIsNull() {
            addCriterion("TOTALMNY is null");
            return (Criteria) this;
        }

        public Criteria andTotalmnyIsNotNull() {
            addCriterion("TOTALMNY is not null");
            return (Criteria) this;
        }

        public Criteria andTotalmnyEqualTo(BigDecimal value) {
            addCriterion("TOTALMNY =", value, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyNotEqualTo(BigDecimal value) {
            addCriterion("TOTALMNY <>", value, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyGreaterThan(BigDecimal value) {
            addCriterion("TOTALMNY >", value, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("TOTALMNY >=", value, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyLessThan(BigDecimal value) {
            addCriterion("TOTALMNY <", value, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("TOTALMNY <=", value, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyIn(List<BigDecimal> values) {
            addCriterion("TOTALMNY in", values, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyNotIn(List<BigDecimal> values) {
            addCriterion("TOTALMNY not in", values, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TOTALMNY between", value1, value2, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TOTALMNY not between", value1, value2, "totalmny");
            return (Criteria) this;
        }

        public Criteria andRtnqntyIsNull() {
            addCriterion("RtnQNTY is null");
            return (Criteria) this;
        }

        public Criteria andRtnqntyIsNotNull() {
            addCriterion("RtnQNTY is not null");
            return (Criteria) this;
        }

        public Criteria andRtnqntyEqualTo(Integer value) {
            addCriterion("RtnQNTY =", value, "rtnqnty");
            return (Criteria) this;
        }

        public Criteria andRtnqntyNotEqualTo(Integer value) {
            addCriterion("RtnQNTY <>", value, "rtnqnty");
            return (Criteria) this;
        }

        public Criteria andRtnqntyGreaterThan(Integer value) {
            addCriterion("RtnQNTY >", value, "rtnqnty");
            return (Criteria) this;
        }

        public Criteria andRtnqntyGreaterThanOrEqualTo(Integer value) {
            addCriterion("RtnQNTY >=", value, "rtnqnty");
            return (Criteria) this;
        }

        public Criteria andRtnqntyLessThan(Integer value) {
            addCriterion("RtnQNTY <", value, "rtnqnty");
            return (Criteria) this;
        }

        public Criteria andRtnqntyLessThanOrEqualTo(Integer value) {
            addCriterion("RtnQNTY <=", value, "rtnqnty");
            return (Criteria) this;
        }

        public Criteria andRtnqntyIn(List<Integer> values) {
            addCriterion("RtnQNTY in", values, "rtnqnty");
            return (Criteria) this;
        }

        public Criteria andRtnqntyNotIn(List<Integer> values) {
            addCriterion("RtnQNTY not in", values, "rtnqnty");
            return (Criteria) this;
        }

        public Criteria andRtnqntyBetween(Integer value1, Integer value2) {
            addCriterion("RtnQNTY between", value1, value2, "rtnqnty");
            return (Criteria) this;
        }

        public Criteria andRtnqntyNotBetween(Integer value1, Integer value2) {
            addCriterion("RtnQNTY not between", value1, value2, "rtnqnty");
            return (Criteria) this;
        }

        public Criteria andBasicrtnqntyIsNull() {
            addCriterion("BasicRtnQnty is null");
            return (Criteria) this;
        }

        public Criteria andBasicrtnqntyIsNotNull() {
            addCriterion("BasicRtnQnty is not null");
            return (Criteria) this;
        }

        public Criteria andBasicrtnqntyEqualTo(Integer value) {
            addCriterion("BasicRtnQnty =", value, "basicrtnqnty");
            return (Criteria) this;
        }

        public Criteria andBasicrtnqntyNotEqualTo(Integer value) {
            addCriterion("BasicRtnQnty <>", value, "basicrtnqnty");
            return (Criteria) this;
        }

        public Criteria andBasicrtnqntyGreaterThan(Integer value) {
            addCriterion("BasicRtnQnty >", value, "basicrtnqnty");
            return (Criteria) this;
        }

        public Criteria andBasicrtnqntyGreaterThanOrEqualTo(Integer value) {
            addCriterion("BasicRtnQnty >=", value, "basicrtnqnty");
            return (Criteria) this;
        }

        public Criteria andBasicrtnqntyLessThan(Integer value) {
            addCriterion("BasicRtnQnty <", value, "basicrtnqnty");
            return (Criteria) this;
        }

        public Criteria andBasicrtnqntyLessThanOrEqualTo(Integer value) {
            addCriterion("BasicRtnQnty <=", value, "basicrtnqnty");
            return (Criteria) this;
        }

        public Criteria andBasicrtnqntyIn(List<Integer> values) {
            addCriterion("BasicRtnQnty in", values, "basicrtnqnty");
            return (Criteria) this;
        }

        public Criteria andBasicrtnqntyNotIn(List<Integer> values) {
            addCriterion("BasicRtnQnty not in", values, "basicrtnqnty");
            return (Criteria) this;
        }

        public Criteria andBasicrtnqntyBetween(Integer value1, Integer value2) {
            addCriterion("BasicRtnQnty between", value1, value2, "basicrtnqnty");
            return (Criteria) this;
        }

        public Criteria andBasicrtnqntyNotBetween(Integer value1, Integer value2) {
            addCriterion("BasicRtnQnty not between", value1, value2, "basicrtnqnty");
            return (Criteria) this;
        }
    }

    /**
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}